Configuring CheckPoint to Use Microsoft SQL Server

SoftwareShield CheckPoint™ License Server > CheckPoint Database > Configuring CheckPoint™ to Use Microsoft SQL Server®

## Configuring CheckPoint™ to Use Microsoft SQL Server®

Configuring the CheckPoint License Server to use Microsoft SQL Server as its database requires:

- That you have familiarity with the principles of how to administer SQL Server. In particular that you are comfortable with SQL Enterprise Manager and SQL Query Analyzer.

- That you understand that using these tools incorrectly could cause the irreversible loss of data on your SQL Server instance.

To configure the CheckPoint License Server to use Microsoft SQL Server as its database:

1. Ensure that the server machine (or an accessible server on the network) has Microsoft SQL Server 2000 or later installed.

2. Open SQL Query Analyzer. Connect to the SQL server instance you will install the CheckPoint database on.

3. Open the SQL script "SETUP-MSSQL-CheckPoint.sql" from your \SoftwareShield\CheckPoint\ directory in SQL Query Analyzer.

4. If you use a different directory that the default one MS SQL server provides for data ("C:\Program Files\Microsoft SQL Server\MSSQL\data\"), modify the script in the noted locations near the top of the file to supply the full path to your desired "data" directory.
   WARNING: Running this script will DROP the CheckPoint Database if it already existed on the server and will destroy all data contained inside it. ONLY run this script if you have never set up the database before OR, you are willing to lose all data inside any existing database.

5. Execute the script. This will set up the database (named "CheckPoint") with all its objects, constraints etc., and will set up a SQL Server database user for you with full access to the database (named "cpuser"). If you wish to use this user, you MUST now change the password for this user in the Security / Logins node of the server instance in SQL Server Enterprise Manager. Otherwise, you may set up your own user name. Be sure to give the user full ownership access to the CheckPoint database.

Once the database is set up, you may wish to re-start the SQL server instance (although technically this should not be necessary we have found some initial connection issues are solved by a re-start).

Now, configure the CheckPoint Server to connect to the new database by using the License Managers Remote Administrator. See: Configure CheckPoint Server Database.

When you get to the database connection configuration dialog, click the "Microsoft SQL Server" radio button and fill out the fields as shown below:

Note that as shown, if the SQL Server instance is installed on the same machine as the CheckPoint Server, the default name for the local SQL server instance is "(local)" not "local". This of course can be different if you names your local instance something different.

Enter the server instance name in the "Server Name" edit box, the database name (by default "CheckPoint") and the SQL server user name and password to use to access the database.

When you accept the location connection details, the CheckPoint Server will be contacted to make the configuration change. It will also test that the database file can be located, opened and that all the appropriate tables have been found. If any problem is encountered, the error will be reported to you.

Note: The SoftwareShield CheckPoint™ License Server only comes with the Server Edition of the SoftwareShield System.